Main
Kyle McGillicuddy-Penna
I have made visualizations viewed by hundreds of thousands of people, sped up query times for 25 terabytes of data by an average of 4,800 times, and built packages for R that let you do magic.
Currently searching for a position that allows me to build tools leveraging a combination of visualization, machine learning, and software engineering to help people explore and understand their data in new and useful ways.
Skills
Communication: action oriented translator.
N/A
N/A
N/A
- Proven ability to connect with stakeholders across functions, teams, and experience levels.
- Practiced listener, precise speaker, analytical thinker.
- Eliminate vagueness, even while describing complexity or uncertainty.
- Ask hard questions and push for answers that drive improvements.
- Graphical communication via Tableau, R, Excel.
Data access: experienced SQL writer, reader, and editor.
N/A
N/A
N/A
- PLSQL package development.
- Query optimization in a medium to large (billion row, non-distributed) data setting.
Data analysis: R to read, wrangle, explore, visualize, and model, mostly via the tidyverse.
N/A
N/A
N/A
Data storage (warehousing + ETL) via:
N/A
N/A
N/A
- Dimensional modeling: star + snowflake schemas + Kimball best practices.
- Database design: table creation and data normalization, data typing, constraints, indexes.
- PLSQL: scheduler + packages + triggers + stored procedures.
- Pentaho’s Data Integration.
- Cron + shell scripts.
Education
B.A. in Engineering Psychology
Tufts University
Medford, Massachusetts.
2004 - 2000
- Honors, Dean’s List.
Minor in Studio Art
The School of the Museum of Fine Arts
Boston, Massachusetts.
2004 - 2003
Selected Positions
Inmar
Data Governance Lead
Seattle, WA
2020 - 2019
YOU Technology (purchased by Kroger in 2014)
Business Intelligence Lead
Daly City, California
2019 - 2012
- Focus on scaling data resources to support 100%+ yearly customer and revenue growth over multiple years.
- Own data related product development process: ensure clear and achievable requirements, leading to better tools to inform decision makers.
- Hire, manage, and mentor a small team of engineers and analysts.
YOU Technology
Senior Business Analyst
Daly City, California
2012 - 2011
- Collaborate with management to identify, track, and present best metrics of business impact; present those metrics to team leaders via executive dashboards.
- Build and maintain data warehouse and client facing reporting site to allow retailers to independently monitor and analyze campaigns.
YOU Technology
Business Analyst
Daly City, California
2011 - 2007
- Compile business reviews to identify trends, recognize successful tactics, and uncover areas for improvement as YOU Tech builds the first digital coupon platform.
- Support successful integration with multiple retailers’ heterogeneous and minimally documented loyalty and POS systems through data exploration and ongoing data quality monitoring.
- Reduce average report development time exponentially by creating reusable parameterized SQL+shell script.
Loyalty Matrix (purchased by Responsys in 2007)
Business Analyst
San Francisco, California
2007 - 2005
- Model customer lifetime value across segments to ensure investments in acquisition and retention are profitable.
- Analyze campaign and email performance to identify effective messaging, timing, and targeting.
- Manage offshore development team to coordinate completion of multiple concurrent ETL and QA processes on deadline and within budget.
Private Residence
Chef
San Francisco, California
2005 - 2004
Department of Transportation, Research Center
Research Assistant
Cambridge, MA
2004 - 2003
- Assist lead investigators with all aspects of experiments (design, description, information collection and analysis) on operator fatigue and automated crash avoidance systems.
- Lead the evaluation and selection process of motion trackers to be used in research.